SSpread.TypeDateMax Property

Set the upper limit of the date that can be entered in a date type cell.

Only valid for cells with the CellType property set to $CellTypeDate (date type). Before setting this property, use the Col , Row properties etc. to specify what you want to process.

Specify in YYYYMMDD format. The initial value is “20991231” .

Specify the lower limit with the TypeDateMin property. The spin button displayed by the TypeSpin property allows you to increase or decrease the value within the specified range. When the TypeSpinWrap property is set to $TRUE , the values ​​that have reached the upper and lower limits are wrapped.

This property is subject to property inheritance of date type cells.

Points to note when specifying a range using lower and upper limits

Example of use

Col = 3;
Row = 2;
CellType = $CellTypeDate;
TypeDateMin = "20000101";
TypeDateMax = "20201231";
Value = str(sysdate(), "YYYYMMDD");
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeDate;
TypeDateMin = "19500101";
TypeDateMax = "20491231";
Value = str(sysdate(), "YYYYMMDD");
BlockMode = $FALSE;

Related item
CellType , TypeDateMin , TypeSpin , TypeSpinWrap property